home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / tallys.sql < prev    next >
Text File  |  2000-05-12  |  621b  |  18 lines
  1. /* RCSVER $Id: tallys.sql,v 1.1 2000-01-28 14:38:34-06 randy Exp $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        tallys.sql
  6. * Date:        01/27/00
  7. * memo:        Randy Wood
  8. * Description:    Create the tallys table. 
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE tallys
  12. (
  13.     ttype      NUMBER(38),        /* ID of this tally type */
  14.     descr        VARCHAR2(20),    /* Description */
  15.     config_num    NUMBER(38),
  16.       CONSTRAINT pk_tallys PRIMARY KEY (ttype, config_num)
  17. );
  18.